SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 57652: Updated SAS/ACCESS® Interface to Greenplum ODBC Driver

DetailsHotfixAboutRate It

In an effort to keep current with bug fixes in the Greenplum driver, SAS has updated the current Greenplum driver.

The hot fixes attached to this SAS Note update two different versions of SAS.

SAS® 9.4M3 (TS1M3) ODBC Driver for Greenplum can be updated to 7.1.5.

Fixes in this driver release include, but are not limited to, the following:

  • The driver no longer stops responding when a SELECT statement contains an SQRT(-1) or LN(-1).
  • Metadata results for SQLColumns and SQLTables no longer contain rows for Greenplum partitioned tables.

The SAS® 9.4M7 (TS1M7) and SAS® Viya® 3.5 ODBC drivers for Greenplum can be updated to a newer version of the current driver 7.1.6. The updated minor version of the driver is 07.16.0389 (B0562, U0408).

Fixes in this driver release include, but are not limited to, the following:

  • Large queries causing crashes in the trace library

Click the Hot Fix tab in this note to access the hot fix for this issue.



Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS/ACCESS Interface to GreenplumMicrosoft Windows 8 Pro 32-bit9.449.459.4 TS1M79.4 TS1M8
Microsoft Windows 8 Pro x649.449.459.4 TS1M79.4 TS1M8
Microsoft Windows 8.1 Enterprise 32-bit9.449.459.4 TS1M79.4 TS1M8
Microsoft Windows 8.1 Enterprise x649.449.459.4 TS1M79.4 TS1M8
Microsoft Windows 8.1 Pro 32-bit9.449.459.4 TS1M79.4 TS1M8
Microsoft Windows 8.1 Pro x649.449.459.4 TS1M79.4 TS1M8
Microsoft Windows 109.449.459.4 TS1M79.4 TS1M8
Microsoft Windows Server 2012 Datacenter9.449.459.4 TS1M79.4 TS1M8
Microsoft Windows Server 2012 R2 Datacenter9.449.459.4 TS1M79.4 TS1M8
Microsoft Windows Server 2012 R2 Std9.449.459.4 TS1M79.4 TS1M8
Microsoft Windows Server 2012 Std9.449.459.4 TS1M79.4 TS1M8
Microsoft Windows Server 20169.449.459.4 TS1M79.4 TS1M8
Microsoft Windows Server 20199.449.459.4 TS1M79.4 TS1M8
Windows 7 Enterprise 32 bit9.449.459.4 TS1M79.4 TS1M8
Windows 7 Enterprise x649.449.459.4 TS1M79.4 TS1M8
Windows 7 Home Premium 32 bit9.449.459.4 TS1M79.4 TS1M8
Windows 7 Home Premium x649.449.459.4 TS1M79.4 TS1M8
Windows 7 Professional 32 bit9.449.459.4 TS1M79.4 TS1M8
Windows 7 Professional x649.449.459.4 TS1M79.4 TS1M8
Windows 7 Ultimate 32 bit9.449.459.4 TS1M79.4 TS1M8
Windows 7 Ultimate x649.449.459.4 TS1M79.4 TS1M8
64-bit Enabled AIX9.449.459.4 TS1M79.4 TS1M8
64-bit Enabled Solaris9.449.459.4 TS1M79.4 TS1M8
HP-UX IPF9.449.459.4 TS1M79.4 TS1M8
Linux for x649.449.459.4 TS1M79.4 TS1M8
Solaris for x649.449.459.4 TS1M79.4 TS1M8
Microsoft® Windows® for x649.449.459.4 TS1M79.4 TS1M8
Microsoft Windows 8 Enterprise 32-bit9.449.459.4 TS1M79.4 TS1M8
Microsoft Windows 8 Enterprise x649.449.459.4 TS1M79.4 TS1M8
SAS SystemSAS ViyaMicrosoft® Windows® for x643.53.5ViyaViya
Microsoft Windows 8 Enterprise x643.53.5ViyaViya
Microsoft Windows 8 Pro x643.53.5ViyaViya
Microsoft Windows 8.1 Enterprise x643.53.5ViyaViya
Microsoft Windows 8.1 Pro x643.53.5ViyaViya
Microsoft Windows 103.53.5ViyaViya
Microsoft Windows Server 2003 for x643.53.5ViyaViya
Microsoft Windows Server 2008 R23.53.5ViyaViya
Microsoft Windows Server 2008 for x643.53.5ViyaViya
Microsoft Windows Server 2012 Datacenter3.53.5ViyaViya
Microsoft Windows Server 2012 R2 Std3.53.5ViyaViya
Microsoft Windows Server 2012 Std3.53.5ViyaViya
Microsoft Windows Server 20163.53.5ViyaViya
Windows 7 Enterprise x643.53.5ViyaViya
Windows 7 Home Premium x643.53.5ViyaViya
Windows 7 Professional x643.53.5ViyaViya
Windows 7 Ultimate x643.53.5ViyaViya
Windows Vista for x643.53.5ViyaViya
Linux for x643.53.5ViyaViya
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.